Shareware Grab Bag

home *** CD-ROM | disk | FTP | other *** search

/ Shareware Grab Bag / Shareware Grab Bag.iso / 005 / pcgl.arc / MANUAL < prev next >

Wrap

Text File | 1985-08-26 | 47KB | 1,507 lines

CHARTER SOFTWARE'S PC - GENERAL LEDGER (Copyright 1984, 1985 Gerald V. Fricke) USER SUPPORTED SOFTWARE This program is being distributed under the `FREEWARE' concept developed by Andrew Fluegelman. The idea is that an individual or a company using a program and finding it of value will compensate the author by voluntarily sending him a nominal fee. You are encouraged to copy this program and give it to others who may have a use for it. The only restriction is that you do not change any of the code and that you do not charge anything for the programs. If you are using this program and find that it has value, your contribution of $50.00 would be appreciated. Upon receipt of your contribution, you will be become a registered owner of PC - GENERAL LEDGER. This will entitle you to a copy of the most recent manual, telephone support, and all updates and enhancements as they become available. The registered name will appear on the initial screen and at the top of various reports. NOTE: IF YOU HAVE JUST RECEIVED YOUR REGISTERED COPY AND HAVE CREATED DATA WITH SOMEONE ELSE'S COPY OF VERSION 1.3 OR 1.3a AND YOU WANT TO SAVE THAT DATA, DO THE FOLLOWING: 1. If you are working with a floppy disk system, put your existing `A' disk in drive A and the registered disk you just received in drive B. 2. At the DOS A> prompt, type COPY B:*.EXE 3. If you have a hard drive, put the new disk in drive A, and at the DOS prompt for your hard disk, type COPY A:*.EXE 4. Your working disks now have the new programs and are ready to go. Gerry Fricke CHARTER SOFTWARE P.O. Box 70 Monticello, IL 61856 217-762-7143 PC - GENERAL LEDGER Version 1.3a TABLE OF CONTENTS Page Getting Started 1 Initialization 2 Introduction 4 Summary 6 Data Entry 6 Chart of Accounts 8 Add new account 8 Delete account 9 Change account name 9 Print chart of accounts 9 Practice Entries 10 Enter Transactions 10 Cash receipts 11 Check stubs 13 Journal entries 13 Recurring journal entries 14 Write Checks 15 Transaction Register Printouts 16 Trial Balance Print-out 17 Financial Statements 18 Month or Year End Close 18 Utilities and Maintenance 19 Vendor Maintenance 20 Create a DIF file for Lotus 1-2-3 21 Page 1 GETTING STARTED THIS MANUAL IS FOR VERSION 1.3a. THE PROGRAMS FOR THIS VERSION ARE NOT COMPATIBLE WITH DATA CREATED BY VERSIONS 1.0 THROUGH 1.2. If have files created by previous versions and want to transfer them to Version 1.3a, send a check for $10.00 for instructions and a program for converting files. PC - GENERAL LEDGER requires either two double sided floppy disks or a hard disk system. It will run under either DOS 1.1, DOS 2.0 or DOS 2.1. The programs will run on the Compaq and other IBM compatible computers. If you are using a floppy system the programs and control file are on drive A and the data disk is put in drive B. The disk for drive B should not have DOS on it so that maximum space is available. If you have a hard disk, it is suggested that you create a separate directory for the programs and then copy the disk you received to that directory. Hard disk users, skip to the paragraph beginning `Put the disk ..' If you are working with two floppy drives, the first thing to do is to format a disk and put your operating system on it. This is normally done by putting your original DOS disk in drive A, an unformatted disk in drive B, and typing FORMAT B:/S. Then, transfer everything on the disk you received to the working disk that you created. This can be done by putting your freshly formatted disk in the A drive, the disk you received in the B drive, and then typing COPY B:*.* A: and then pressing ENTER. The following files and programs are necessary to make PC - GENERAL LEDGER function properly and must be on the `A' disk or the hard drive. BASRUN.EXE GLENTRY.EXE GLCTRL.FIL GLCHECKS.EXE GLMENU.EXE GLTRIAL.EXE GLCHART.EXE GLSTATE.EXE During the initialization part of the program, the proper files for the `B' drive are created automatically. Put the disk you received in a safe place in case that something happens to your working disk and you have to start over. If the disk you received has someone else's general ledger data already on it, the initialization will remove the data and reset the files properly. Page 2 In order to start the program type `GLMENU' at the DOS prompt. The first thing that you will need to do is to enter the date. All dates are entered as 6 digits such as 060484. The computer will automatically format it to read 06-04-84. After you have entered the date, the main menu appears: Page 1 = Enter TRANSACTIONS or WRITE CHECKS 10-15 2 = CHART of Accounts or VENDOR Maintenance 8,20 3 = Print TRIAL BALANCE 17 4 = Print TRANSACTION Registers 16 5 = Print FINANCIAL Statements 18 6 = Month or Year End CLOSE 18 7 = DATE Change 8 = UTILITIES or INITIALIZATION 2,19 9 = Create a 'DIF' for LOTUS 21 10 = END of Session Choose option 8 from this menu. INITIALIZATION The screen you see allows to make changes to some base information. For instance, you can type in a second and third line, such as address, city and state, etc. that will appear on the Statement of Income and Balance Sheet only. You will then be asked to type in the month that your fiscal year ends. (October=10, December=12, etc.) After that, you have to tailor the programs to your hardware system. The next menu looks like this: MONITOR SELECTION: 1 = IBM Monochrome 2 = OTHER Monochrome 3 = COMPOSITE Color 4 = RGB Color 5 = Compaq DRIVE SELECTION: 6 = 320K Floppy disks 7 = 360K Floppy disks 8 = HARD Drive 9 = INITIALIZATION 10 = CLEAR All Account Balances 11 = MAIN MENU You will now need to choose which monitor you are using and which drive system. After making the selections, select option 9 to finish the initialization process. This final process sets up the necessary accounts and zeros all of the files so that PC - GENERAL LEDGER will function properly. Page 3 If you have a floppy disk system you will need to have a formatted disk (without a system on it) ready for drive B. The procedure is very simple and the instructions on the screen will take you through the necessary steps. You will only need to identify which account number and name will be used for the account that you make your cash deposits to and the account number and name which you write checks on. They can be either the same account or different ones. The program automatically assigns account number 3999 to Retained Earnings. You cannot change that number but are free to change the description. After the initialization is complete, you will be taken back to the Main Menu and you are ready to use PC - GENERAL LEDGER. Page 4 INTRODUCTION IT IS EXTREMELY IMPORTANT THAT YOU EXIT THE PROGRAM BY SELECTING OPTION 10 (END OF SESSION) AT THE MAIN MENU. IF YOU TURN OFF THE COMPUTER OR REMOVE THE DISKS AT ANY OTHER TIME, YOU MAY LOSE YOUR DATA AND HAVE TO START OVER. BACK UP YOUR DISKS ON AT LEAST A DAILY BASIS. Neither you, your hardware, or the software author are infallible. Problems will occur. That's why BACKUPS are so important. BACKUP YOUR DISKS ON A REGULAR BASIS. IF FOR ANY REASON, YOU GET AN ERROR MESSAGE OR THE PROGRAM STOPS WORKING PROPERLY, IT IS IMPORTANT THAT YOU HAVE BACKUPS AVAILABLE SO THAT YOU DO NOT HAVE TO START OVER FROM SCRATCH. This program was written by a financial executive with over 25 years of experience in all areas of accounting, finance, taxes, and general management. The program has all of the controls necessary to make sure that everything is kept in balance and that a complete audit trail always exists. This manual and the programs assume that you have a working knowledge of bookkeeping, know the difference between debits and credits and know how to prepare and post entries. Charter Software's PC - GENERAL LEDGER is easy to use and we have done our best to see that you can't get into trouble. However, we can't detect typing errors such as `10.00' when you mean `100.00' or `espense' when you mean `expense'. The programs do provide two important safeguards: 1. All entries must balance. You will not be able to post an entry that does not. 2. There is a complete audit trail. Amounts cannot be posted to the general ledger until the details have been printed out to the printer. If you are a registered owner, your name is coded as part of the program and there is no provision for you to change it. If, for some reason you need it changed, send a blank disk and a prepaid mailer (or a check for $10) along with the change that you need and you'll get a new disk with the change by return mail. Page 5 The general ledger system consist of eight working segments: CHART OF ACCOUNTS This enables you to add new accounts to the general ledger and change the name of an existing account or delete an account. ENTER TRANSACTIONS This is the main part of the general ledger package. You can make entries into the cash receipts journal or the general journal. You can either print checks on the printer or post check stubs to the check register. PRINT REGISTERS This part of the program enables you to print out the entries that you have made. After printing out the entries, the trial balance and general ledger can be updated. TRIAL BALANCE This will print out the beginning balance, all entries, and the ending balance for each account. The program maintains two trial balances. One is for the month to date and the other is year to date. FINANCIAL STATEMENTS This enables you to print out the balance sheet and profit and loss statement with month and year to date totals. MONTH AND YEAR END CLOSE This lets you close the books at month and year end in order to start the next accounting period. This segment also allows you to erase the year to date trial balance if you need additional room on your floppy disks to handle current transactions. UTILITIES AND INITIALIZATION Allows you to configure the programs to your particular hardware and/or initialize all of the general ledger files. DIF FILES FOR LOTUS You can create files that can be read by Lotus 1-2-3. These files can contain the account number, account name, month and year to date balance for various accounts. The files created are 'DIF' files which Lotus can convert to 'WKS' files which it can then bring into its spreadsheet. If you wish you can print checks on your printer using pre- printed customized check forms. The checks are available from Colwell Systems, Inc., 201 Kenyon Road, Champaign, IL 61820. The checks are catalog number 9045 and should be ordered without pre printed check numbers since the program prints the check number on the check form. The phone number is 800-248-7000 (Illinois - 800-233-7777) Page 6 SUMMARY - Daily entries show up on the screen as you make them. - All entries are saved on disk until you print them out and update the general ledger. - When you update the general ledger, the entries are then posted to both the month and year to date trial balances. - Once entries have been made to the trial balance, you can print out the trial balances and financial statements. - The month end close clears the files for the next month's entries. - You can transfer data to a DIF file which can be read by Lotus and certain other spreadsheets. - The program maintains a 'vendor' file. This means that you can automatically print names and addresses on checks. There is nothing sacred about a 'month'. You can close your books weekly, quarterly, or annually. This manual assumes that you are using a monthly system, but the programs will work with any accounting period. DATA ENTRY The program will accept individual entries up to 9,999,999.99 and print values up to 99,999,999.99 and supports both upper and lower case. Whenever the computer is waiting for you to type something, the cursor will be blinking at the first dot in a row of dots. The number of dots indicates the maximum number of characters allowed for your input. When typing numbers, do not have to put in the decimal point if it is a round dollar amount. For instance, if you type 10 for 10 dollars, the program will automatically format and display it as 10.00. Entering 9.5 will result in 9.50. This can save a lot of keystrokes. Do not type commas when entering numbers. The program, however, will automatically put them in. If you are entering a negative number, you can put the minus sign either before or after the number. Messages about what to enter or how to enter it are normally at the bottom of the screen. When in doubt, look for that message line. Page 7 If you hear a `tone', you have probably typed something wrong and the message at the bottom of the screen will tell you what to do next. This is always an `escape route' if you make a mistake. Pressing `ENTER' or `ESC' will normally take you back to a point where you can recover and start again. Before any significant item gets entered or changed, you will get a chance to change your mind. If you are using a floppy disk system, the bottom of the screen will show the approximate amount of disk space used on your data disk based on the size of the floppy disks you indicated in the hardware configuration. If you are using the IBM monochrome monitor, some words should be highlighted. If not, adjust the two knobs on the monitor. If you are using a color monitor, some words will be in color. IMPORTANT Make sure that you do not turn off your computer or take out the disks in the middle of the program. If you do, you are almost certain to lose data. Always go back to the Main Menu and choose option 10 (END of session). Make sure that you back up your working disks on a regular basis. If you are using a floppy disk system, it's extremely important that you back up both the A and B disks at the same time since they are inter-related. ERRORS If you run into a programming error, the screen will clear and you will get a message telling you the error number and the program line in which it occurred. Please let us know if you run into any errors and the circumstances. A description of the error messages is in the appendix of your BASIC manual. Page 8 CHART OF ACCOUNTS The chart of accounts numbering system has been pre-set as shown below. You are limited to 500 different account numbers. You can allocate them between the various categories such as assets, liabilities, income, etc. however you wish. The chart of accounts maintenance menu looks like this: MAINTENANCE Page CHART OF ACCOUNTS: 1 = Add NEW Account 8 2 = DELETE Account 9 3 = CHANGE Account Name 9 4 = PRINT Chart of Accounts 9 OTHER: 5 = VENDOR Maintenance 20 6 = RECURRING Entries 14 ADD NEW ACCOUNT The screen for adding new accounts is shown below: Account Number .... Description ....................... 1000-1499 Current Asset 1500-1699 Fixed Asset 1700-1999 Other Asset 2000-2499 Current Liability 2500-2999 Long Term Liability 3000-3999 Equity 4000-4999 Revenue 5000-5999 Cost of Sales 6000-6999 Expenses 7000-7999 Other Income/Expense After you enter a new account number, the program checks whether or not the number has already been used. If not, the type of account is highlighted at the bottom of the screen and you can then type in the name of the new account. After that, type `A' to accept or `T' to try again. When you are finished adding accounts, pressing `ENTER' takes you back to the menu. You can also add new accounts as you make entries. If you type in the number of an account that is not on file, you will get the opportunity to add the account at that time. The screen that you will see is the same as above. Page 9 DELETE ACCOUNT This option enables you get rid of an account you are no longer using. In order to safeguard the system, you can only delete an account when: - The month and year to date balances for that account are zero. and - You have closed the books for the month. and - You have not made any entries to any account in the new month. and - There are no entries in the year to date trial balance for that account. and - The account is not used in a recurring Journal Entry. When you type in the account number the program checks the above. If all the conditions are met, the program then displays the account name and asks you confirm that you want to make the deletion. Type `D' to delete the account or `N' for no delete. CHANGE ACCOUNT NAME This option lets you change the name of the account in order to better describe it or to correct spelling errors. PRINT CHART OF ACCOUNTS You can display the current chart of accounts on the screen or print them on the printer for easy reference. The print out shows the account number, description and type of account (asset, liability, etc.) Page 10 PRACTICE ENTRIES You can set up your complete chart of accounts and make practice entries to get familiar with the system. When you are comfortable with how every works you can clear all of your practice entries and start entering your real data. See page 17. ENTER TRANSACTIONS The procedure for entering transactions is essentially the same whether you are doing cash receipts, posting check stubs or journal entries. There are only minor differences in the screen layout and how data is entered. If you are using the program to print checks, you will provide the program with the necessary information such as date, check number, payee, etc. The program will then ask you to provide the necessary accounting information in order to automatically post the entry. Entering the accounting data is done in the same manner whether you are posting from check stubs or actually printing checks. Each accounting entry is a two step process. First you type in the `header' information such as date, description, etc. The second part is entering account numbers and amounts. If you make a mistake there is a simple procedure to correct or change an entry so that you do not have to start over. You can have up to 15 different accounts in a single entry. Near the bottom of the screen is the `Entry Balance' figure. This is updated after every amount is entered and shows how much the entry is `out of balance' at that point. Until you are familiar with the program, the key to making entries is to keep an eye on the message line at the bottom of the screen. It will prompt you as to what is expected next. The menu for the transaction program is shown below. You can choose to enter cash receipts, checks written, journal entries, or write checks. Page ENTER TRANSACTIONS: 1 = CASH Receipts 11 2 = Enter CHECK STUBS 13 3 = JOURNAL Entries 13,14 4 = WRITE CHECKS 15 Page 11 CASH RECEIPTS The screen layout for cash receipts looks like this: POST CASH RECEIPTS Last Cash: Date ...... Description ................ Ref:....... Line Acct Account Title Amount ----------- Cash Balance: Entry Balance TYPE CASH RECEIPTS DATE (MMDDYY) `ENTER' FOR TODAY'S DATE `ESC' WHEN DONE The program assumes that you have already made a deposit and are entering an accounting summary of that deposit. If your cash receipts and cash disbursements are run through the same account number, your present cash balance is in the lower left hand corner of the screen. It is automatically updated every time you make an entry to that account. It is possible for this figure to be incorrect the first month you use the program. However, it is automatically reset to the general ledger balance at each month end close. For reference purposes, the last cash receipts date that you posted is in the upper right hand corner of the screen. You can type in the date or press `ENTER' and the date you entered on start up will be automatically displayed. You can type any description you want to describe the entry. You also have an eight character reference field if you need it. Pressing `ENTER' at either place will create a blank description or reference and move you to the next field. Whatever information that you type into the header will show on the registers when you print them out. After the reference field, type `A' to accept the header or `T' to try again. Once you have accepted the header, it is time to enter account numbers and amounts. The entry can be up to 15 lines. The cash account number and description is automatically put on line 1 and cursor is waiting in the amount column. (Remember, you do not have to enter the decimal point if it is a whole dollar amount). After you type in the amount, it is formatted and displayed and the `Entry Balance' amount is updated. Page 12 Then line by line, you finish the accounting distribution. First you enter either the account number or up to four letters of the account name. If you enter the account number, the program will automatically display the account description. If you type `RENT' the program will search for the first account having `RENT' in the description and display the account number and account description. If you are looking for `RENT EXPENSE' and the first account with `RENT' is `RENTAL INCOME', the program will display that one first. However, pressing `ENTER' again will find the next account with `RENT' in it. You can continue to press `ENTER' until you find the right account or reach the end of the account number file. If you type in an account number and that account is not on file, the program will ask you whether you want to add that number to the file. The following message will appear at the bottom of the screen: NUMBER NOT ON FILE. TYPE 'A' TO ADD 'T' TO TRY AGAIN If you want to add that number to the chart of accounts, type 'A' and you will see the same screen that is used to set up new accounts in the Chart of Accounts section of the program. All you need to do is type in the description of the account and you will be taken back to where you were in the entry. The new account has been set up and will be there. Once you have the proper account, the next step is to enter the amount. If it is a simple two line entry, pressing `ENTER' will automatically display the offsetting amount from line 1. Otherwise, you will have to type in the amount. As you enter amounts line by line, the `Entry Balance' amount will be updated. When that amount is zero, the entry is in balance and the following message is at the bottom of the screen: TYPE `A' TO ACCEPT (`ENTER' TO MAKE CHANGES) If you type `A' the entry is recorded on disk, the data is cleared from the screen, and you are ready for the next entry. (At that point, if you are done with cash receipts, pressing `ESC' will take you the menu.) If you need to make changes to the entry you were working on and pressed `ENTER' instead of `A', then you have the opportunity to change any of the lines in the entry or to add additional lines. This saves having to re-do the entire entry. The program will ask you for the line number to be changed. That line will be erased and you then enter a new account number and amount. You can continue in this manner until you have the changes made and the entry balances. At that point, type `A' to accept and move on to the next entry. Page 13 ENTER CHECK STUBS This section of the program enables you post from check stubs if you are not using the program to actually print checks. Transactions are posted here in the same manner as cash receipts with minor exceptions. The header is different in that it calls for a `check number' instead of a `reference'. The program will automatically put in the next check number (based on the last check number shown in the upper right hand corner of the screen) if you press `ENTER' in the Check Number field. Line 1 of the posting section is automatically displayed with the cash account number and description. Enter the amount of the check as a debit instead of a credit. The program will automatically format and display it as negative. Again, after getting the proper account on line 2, pressing `ENTER' when you are in the amount column will automatically put in the offsetting amount for line 1. JOURNAL ENTRIES Again, the procedure is essentially the same as cash receipts or checks written with minor changes in the header. No account number or description is automatically displayed on the line 1. Page 14 RECURRING JOURNAL ENTRIES You have the ability to establish up to 15 entries that you expect to be the same each month. These entries are set up only once and the program keeps track of them for easy recall and posting. In order to set up recurring entries, choose option 2 from the Main Menu and then option 6 from the Chart of Accounts and Vendor Maintenance Menu. The Recurring Journal Entry Menu is as follows: 1 = Set up NEW Entry 2 = DELETE an Entry 3 = LIST Entry Descriptions 4 = DISPLAY Individual Entry 5 = Return to previous MENU In order to set up a recurring entry, you will first need to identify the number to be used (1 through 15) and the description of the entry. After that, you identify the account numbers and the amount to debited or credited to each account. You must balance the entry before the program will save it on disk. Option 2 will allow you to delete an entry that you no longer need. Option 3 will list the descriptions of all the recurring journal entries. Option 4 will display an entry, showing all of the account numbers, account names, and posting amounts for that entry. USING RECURRING ENTRIES In order to post one of the recurring entries, select Journal Entries from the main posting menu. For Journal Entry number type `RJ' plus the number. For instance, to post recurring journal entry number 1, type `RJ1'. The program will automatically put the entry on the screen. At this point, the entry is the same as any other entry. It can be accepted as is, added to, or changed. If you choose a line to change, you will only have to change the amount. The account number and account name do not need to be changed. Making changes and/or additions to the entry during the posting operation does not change the recurring entry that you originally set up. Page 15 WRITE CHECKS Using this option enables you to print checks on the computer instead of writing them by hand and then making an entry for the check stubs. You can mix check stub entries and actual check printing without causing any problems. The program provides for the opportunity of using a vendor file for names and addresses of people you write checks to on a regular basis. You can have up to 100 vendor names and addresses on file at any one time. When you choose the 'Write Checks' option you will be asked whether you want to use the vendor file or not. If you choose not to, you will have to type in the name and address of every check you write. If you choose the vendor file option, you have two advantages. The name and address can be pulled from the vendor file by typing a few letters of the name. For instance, if you have ABC Contracting Corporation in the file, you can bring up their name and address by typing 'ABC'. If you also have a company called ABC Sanitation Service Co., all you have to do is type 'N' and the program will find the next match to 'ABC'. If the name you type is not on file, you will be given the opportunity to add it to the file automatically for use the next time. You also have the option of just typing in the name and address and not adding it to the file. The program puts a picture of a blank check on the screen and all you have to do is `fill in the blanks'. By pressing `ENTER' at the date, the `system' date will be entered. Pressing `ENTER' at the check number will automatically insert the next check number. If you are using the same account number for receipts and disbursements, your present bank balance is shown on the left above the check outline. (See page 9 for more details) After entering the payee, amount, and address, you can put a message on the check stub by typing something on the `For' line. After completing the check form and typing `A' to accept, the screen will change so that you can enter the various accounts and amounts in order to complete the entry. This segment is the same whether you are entering check stubs or actually entering checks to be printed. The program saves all of the checks to be printed so you can print them all at once. You can print a test check to make sure that the check forms are lined up properly prior to printing the actual checks. Page 16 TRANSACTION REGISTER PRINTOUTS As you make each entry during the course of the month it is added to one of the three registers (cash, check or journal entry). You can print out any of one of these registers at any time in order to check out your work or to make copies for your files. As entries are made they are added to the end of each register. If, for instance, you did not make your check stub entries in numeric order, you will have the option of having them sorted prior to printing. Checks are sorted in check number order, cash receipts in date order, and journal entries by journal entry number. After a print-out is finished, the following message is at the top of the screen: TYPE `U' TO UPDATE TRIAL BALANCE AND GENERAL LEDGER AND CLOSE THIS REGISTER (`ENTER' TO EXIT). If you press `U' all of the entries for that register will posted to the month and year to date trial balances and the general ledger. At the bottom of the print-out a message will print indicating that the posting has taken place. The register will then be erased from the disk. You have to decide whether to close the register and update the general ledger at the end of any register print-out. CONSIDERATIONS 1. Financial Statements - The trial balance, statement of income, and balance sheet will only be updated when the register is closed out. 2. Printed Reports - Closing a register several times during the month will mean having your check register, for instance, on several pieces of paper rather than on one print-out. Closing the register only at month end makes the print-out a `complete' one. 3. Disk Usage - Closing a register frees up disk space. If your disk usage exceeds 90%, you should probably close one or more registers to be on the safe side. A month end close also frees up space. The best way to free-up disk space is to erase the year to date trial balance. Choose option 6 from the main menu. Be sure that you print out the year to date trial balance before you delete it. Erasing the file does not change any balances. It just means that you will no longer have all entries since the beginning of the year for a single account listed in one place. You can stop any print-out at any time by pressing `ESC'. This will not affect any of the data in the computer or on the disk. Page 17 TRIAL BALANCE PRINT-OUT You have three options on the trial balance: 1. Print out a complete trial balance 2. Display or print an individual account. 3. Print out a 'Short Form' trial balance. Note: As indicated before, any entries on a register that is not closed out will not be included on the trial balance. If any registers are open, you will receive a message to that effect before the complete trial balance is printed. You will be given an opportunity to close the registers if you wish to do so. You will have the option of printing either the month to date or year to date trial balance for any account or for all accounts. The complete trial balance prints the number of the account, its name, the beginning balance, all entries posted to that account during the month (or year to date), and the ending balance. For profit and loss accounts, the year to date ending balance is shown also. The print-out can be stopped at any time by pressing `ESC'. (If you are using a print spooler, the printing may not stop until the spooler is empty) The final line on the complete print-out shows a `proof' amount. It should show `zero'. However, the BASIC language that was used in writing this program will not always do its math properly. Any errors that occur are normally less than a penny. The point to remember is that if the trial balance and/or financial statements are off by a penny or two, it was not caused by your entries. It is the fault of the programming language and you should not be concerned about it. You can also look at individual accounts. In this instance, you will be given the choice of displaying the account on the screen or printing it on the printer. You can also print out a short form trial balance. This lists the account name, account number, month to date balance, and year to date balance. No detailed entries are shown. Page 18 FINANCIAL STATEMENTS The balance sheet or statement of income can be printed out at any time. It will not include entries on any register that has not been closed out. You will have the choice of having accounts with zero balances printed or not. Again, you can stop the print-out at any time by pressing `ESC'. MONTH OR YEAR END CLOSE When all transactions for the month have been posted and all registers closed out, and you have made all print-outs that you want, you are ready to close the ledger for the month. You will not be able to close out if any one of the three registers is still open. The month end close returns all of the monthly profit and loss balances to zero, updates all of the year to date totals and erases the month to date trial balance detail from the disk. The year end close is the same except that it also zeros out the profit and loss year to date amounts, erases the year to date trial balance, and automatically updates retained earnings with the annual profit. The month end/year end close menu also allows you to erase the year to date trial balance. This option is mainly for the purpose of freeing up disk space. Erasing this trial balance does not have any affect on any balances. Make sure that you make a copy of the trial balance before you erase it. Page 19 UTILITIES AND MAINTENANCE You cannot change the name on your reports. If for some reason you need to have a different name printed than the one that the program is registered to, send a check for $10.00 along with the change that you need and we'll make the change for you. You do have the option of changing the second or third line printed on your income statement and balance sheet as well as the month number of your fiscal year. The maintenance menu also provides for clearing all of your balances without affecting the chart of accounts numbers and names or the vendor file. This option is handy in that you can 'play' with the system by setting up your own chart of accounts, make practice entries, and then erase all of the entries when you are ready to start entering real data. Choose option 10 from the Maintenance Menu. After the system is operating you can also change from a floppy drive system to a hard drive system if you add a hard drive at a later date. Make sure that you copy all of the files from both disks to your hard disk before you change your hardware configuration in the maintenance section of the program. You can also change from a hard disk to a floppy system. However, first make sure that you have completed a month end close. Copy the files `GLDATA.FIL',`GLVEND.FIL', and `GLTB.FIL' from the hard disk to a `B' disk. The files to be transferred to an `A' disk (with DOS already on it) are as follows: BASRUN.EXE GLMENU.EXE GLCHART.EXE GLENTRY.EXE GLTRIAL.EXE GLCHECKS.EXE GLSTATE.EXE GLCTRL.FIL AUTOEXEC.BAT (if appropriate) After you have transferred the files, make sure that you start from the new disk in the `A' drive and not from the hard drive and then move directly to the maintenance option and make the appropriate disk change. Page 20 VENDOR MAINTENANCE The program provides a simple and easy way to maintain up to 100 names and addresses of people you write checks to on a regular basis. Choose option 2 from the Main Menu. This will take you to the Chart of Accounts and Vendor Maintenance menu. Choose option 5 from that menu and you will see the following: 1 = Add NEW Vendor 2 = CHANGE Vendor Data 3 = DELETE Vendor 4 = Print Vendor LISTING No vendor numbers are needed or used. All selections are done by typing a few letters of the company name. If there are several vendors having similar letter combinations, simply typing a 'N' for next will find the next match. For instance, typing 'CO' will find the following names: COLORADO MAGAZINE ABC COMPANY INTERCONTINENTAL MOTORS If you are adding a new name you will have to type in the name, street address, and city, state, and zip. Three lines are provided. The screen to add new names looks like this: Vendor Name: ..................... Vendor Address: ..................... Vendor City & State: ..................... After filling in the blanks, you will be given an opportunity to make any corrections. The name is then added to the file. The screens to Change Data and Delete Vendors are identical. You locate the one you want by typing a few letters of the name and then either make changes or delete the name from the file. Deleting names makes space for additional names, up to 100 total at any one time. You can also add names to the file while you are writing checks. See page 12. Option 4 will give you an alphabetical listing (either on the screen or printer) of all vendors on file. Page 21 TRANSFERRING DATA TO LOTUS 1-2-3 Several spreadsheets, including Lotus 1-2-3, have the ability to read 'DIF' files and bring that data into their work area. DIF stands for Data Interchange Format. You can create DIF files by choosing item 9 from the main menu. You can transfer all or some of the following information: Account Number Account Name Month Balance Year to Date Balance The information when read by the spreadsheet will be in column form. For instance, you could transfer the account number and year to date balance for all accounts to two side by side columns in the spreadsheet. The program will ask you to identify the information you want to transfer. You can select any or all of the above four items and in any columnar order. You can also select which accounts you want to transfer: FILE NAME CREATED All accounts PCGENALL.DIF Balance Sheet only PCGENBAL.DIF Income Statement only PCGENINC.DIF The files created by the program will be on the 'A' disk for floppy system or in the current directory of a hard disk. You will then need to use the COPY command to transfer them to your spreadsheet work disk. Consult your spreadsheet manual on how to convert a DIF file to one that your spreadsheet can read. Note: As of this time, this part of the program has only been tested on Lotus 1-2-3. When using their Translate program use Columnwise vs. Rowwise when that option is presented. Trying the program with other spreadsheets cannot do any harm to the data in PC - GENERAL LEDGER. If you are successful in transferring data to other spreadsheets, please let us know.